﻿using System.Collections.Generic;

namespace Citi.FinancePlanningAnalysis.Domain
{
    public partial class Account
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                {"[Account]", "[Code]"},
                {"[Account Description]", "[Description]"},
                {"[Parent Account]", "[ParentAccount]"},
                {"[Account Type]", "[AccountType]"},
                {"[FMA Group]", "[FMAGroup]"},
                {"[Indicator]", "[Indicator]"}
            };

        #endregion

        public const string QueryMergeDate = "EXEC sp_MergeAllAccount";
        public const string QueryDeletePrevious = "DELETE FROM AccountTemp";

        public const string QueryExcel = @"SELECT 
                    [Account],
                    [Account Description],
                    [Parent Account],
                    [Account Type],
                    [FMA Group],
                    [Indicator]
                FROM [{0}$] WHERE LEN(Account) = 6";
    }
}
